Dataset statistics
| Number of variables | 13 |
|---|---|
| Number of observations | 3144 |
| Missing cells | 312 |
| Missing cells (%) | 0.8% |
| Duplicate rows | 23 |
| Duplicate rows (%) | 0.7% |
| Total size in memory | 788.7 KiB |
| Average record size in memory | 256.9 B |
Variable types
| NUM | 11 |
|---|---|
| CAT | 2 |
| Dataset has 23 (0.7%) duplicate rows | Duplicates |
Project has a high cardinality: 520 distinct values | High cardinality |
Est FY16 is highly correlated with Total | High correlation |
Total is highly correlated with Est FY16 and 6 other fields | High correlation |
6 Year Total is highly correlated with Total and 5 other fields | High correlation |
FY 17 is highly correlated with Total and 3 other fields | High correlation |
FY 18 is highly correlated with Total and 4 other fields | High correlation |
FY 19 is highly correlated with Total and 5 other fields | High correlation |
FY 20 is highly correlated with Total and 4 other fields | High correlation |
FY 21 is highly correlated with Total and 4 other fields | High correlation |
FY 22 is highly correlated with FY 21 | High correlation |
Project is uniformly distributed | Uniform |
Cost Element is uniformly distributed | Uniform |
Total has 1045 (33.2%) zeros | Zeros |
Thru FY15 has 1831 (58.2%) zeros | Zeros |
Est FY16 has 1736 (55.2%) zeros | Zeros |
6 Year Total has 1777 (56.5%) zeros | Zeros |
FY 17 has 2014 (64.1%) zeros | Zeros |
FY 18 has 2066 (65.7%) zeros | Zeros |
FY 19 has 2176 (69.2%) zeros | Zeros |
FY 20 has 2292 (72.9%) zeros | Zeros |
FY 21 has 2384 (75.8%) zeros | Zeros |
FY 22 has 2454 (78.1%) zeros | Zeros |
Beyond 6 Yrs has 2929 (93.2%) zeros | Zeros |
Reproduction
| Analysis started | 2020-12-13 00:57:46.224035 |
|---|---|
| Analysis finished | 2020-12-13 00:57:59.924825 |
| Duration | 13.7 seconds |
| Software version | pandas-profiling v2.9.0 |
| Download configuration | config.yaml |
| Distinct | 520 |
|---|---|
| Distinct (%) | 16.7% |
| Missing | 24 |
| Missing (%) | 0.8% |
| Memory size | 24.7 KiB |
| Libraries | 6 |
|---|---|
| Chapman Avenue Extended (P500719) | 6 |
| Wyngate ES Addition (P116513) | 6 |
| Good Hope Neighborhood Recreation Center (P720918) | 6 |
| Glen Echo Fire Station Renovation (P450702) | 6 |
| Other values (515) |
| Value | Count | Frequency (%) | |
| Libraries | 6 | 0.2% | |
| Chapman Avenue Extended (P500719) | 6 | 0.2% | |
| Wyngate ES Addition (P116513) | 6 | 0.2% | |
| Good Hope Neighborhood Recreation Center (P720918) | 6 | 0.2% | |
| Glen Echo Fire Station Renovation (P450702) | 6 | 0.2% | |
| MCPS Funding Reconciliation (P076510) | 6 | 0.2% | |
| Public Facilities Roads (P507310) | 6 | 0.2% | |
| Potomac WFP Consent Decree Program (P173801) | 6 | 0.2% | |
| Clarksburg HS Addition (P116505) | 6 | 0.2% | |
| Westbrook ES Addition (P116512) | 6 | 0.2% | |
| Clarksburg Cluster ES (Clarksburg Village Site #1) (P116504) | 6 | 0.2% | |
| General Government | 6 | 0.2% | |
| Neighborhood Traffic Calming (P509523) | 6 | 0.2% | |
| Enterprise Facilities' Improvements (P998773) | 6 | 0.2% | |
| School Based Health & Linkages to Learning Centers (P640400) | 6 | 0.2% | |
| Facility Planning: SM (P809319) | 6 | 0.2% | |
| Traffic Improvements | 6 | 0.2% | |
| Rapid Transit System (P501318) | 6 | 0.2% | |
| Public Safety | 6 | 0.2% | |
| Integrated Justice Information System (P340200) | 6 | 0.2% | |
| Council Office Building Garage (P011601) | 6 | 0.2% | |
| Energy Conservation: MCPS (P796222) | 6 | 0.2% | |
| Community Development | 6 | 0.2% | |
| Water Montgomery County | 6 | 0.2% | |
| Universities at Shady Grove Expansion (P151201) | 6 | 0.2% | |
| Other values (495) | 2970 | 94.5% | |
| (Missing) | 24 | 0.8% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 79 |
|---|---|
| Median length | 38 |
| Mean length | 38.3740458 |
| Min length | 3 |
Most occurring characters
| Value | Count | Frequency (%) | |
| 12108 | 10.0% | ||
| e | 8394 | 7.0% | |
| n | 6390 | 5.3% | |
| i | 6054 | 5.0% | |
| a | 6000 | 5.0% | |
| t | 5910 | 4.9% | |
| o | 5604 | 4.6% | |
| r | 5214 | 4.3% | |
| P | 4314 | 3.6% | |
| 0 | 4026 | 3.3% | |
| l | 3336 | 2.8% | |
| s | 3234 | 2.7% | |
| ( | 2940 | 2.4% | |
| ) | 2940 | 2.4% | |
| 1 | 2712 | 2.2% | |
| d | 2532 | 2.1% | |
| c | 2418 | 2.0% | |
| 5 | 2280 | 1.9% | |
| S | 1806 | 1.5% | |
| u | 1698 | 1.4% | |
| m | 1662 | 1.4% | |
| C | 1560 | 1.3% | |
| g | 1458 | 1.2% | |
| 7 | 1458 | 1.2% | |
| 6 | 1446 | 1.2% | |
| Other values (47) | 23154 | 19.2% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Lowercase Letter | 67440 | 55.9% | |
| Decimal Number | 17292 | 14.3% | |
| Uppercase Letter | 16686 | 13.8% | |
| Space Separator | 12108 | 10.0% | |
| Open Punctuation | 2940 | 2.4% | |
| Close Punctuation | 2940 | 2.4% | |
| Other Punctuation | 870 | 0.7% | |
| Dash Punctuation | 372 | 0.3% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| P | 4314 | 25.9% | |
| S | 1806 | 10.8% | |
| C | 1560 | 9.3% | |
| R | 1272 | 7.6% | |
| A | 900 | 5.4% | |
| M | 846 | 5.1% | |
| B | 672 | 4.0% | |
| E | 660 | 4.0% | |
| F | 618 | 3.7% | |
| W | 582 | 3.5% | |
| L | 534 | 3.2% | |
| T | 498 | 3.0% | |
| D | 468 | 2.8% | |
| G | 432 | 2.6% | |
| I | 336 | 2.0% | |
| H | 306 | 1.8% | |
| N | 300 | 1.8% | |
| O | 240 | 1.4% | |
| U | 108 | 0.6% | |
| V | 90 | 0.5% | |
| J | 60 | 0.4% | |
| K | 36 | 0.2% | |
| Q | 30 | 0.2% | |
| Z | 12 | 0.1% | |
| Y | 6 | < 0.1% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| e | 8394 | 12.4% | |
| n | 6390 | 9.5% | |
| i | 6054 | 9.0% | |
| a | 6000 | 8.9% | |
| t | 5910 | 8.8% | |
| o | 5604 | 8.3% | |
| r | 5214 | 7.7% | |
| l | 3336 | 4.9% | |
| s | 3234 | 4.8% | |
| d | 2532 | 3.8% | |
| c | 2418 | 3.6% | |
| u | 1698 | 2.5% | |
| m | 1662 | 2.5% | |
| g | 1458 | 2.2% | |
| p | 1236 | 1.8% | |
| y | 1188 | 1.8% | |
| h | 1062 | 1.6% | |
| v | 1050 | 1.6% | |
| k | 882 | 1.3% | |
| f | 660 | 1.0% | |
| b | 552 | 0.8% | |
| w | 486 | 0.7% | |
| x | 150 | 0.2% | |
| q | 108 | 0.2% | |
| z | 102 | 0.2% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 12108 | 100.0% |
Most frequent Open Punctuation characters
| Value | Count | Frequency (%) | |
| ( | 2940 | 100.0% |
Most frequent Decimal Number characters
| Value | Count | Frequency (%) | |
| 0 | 4026 | 23.3% | |
| 1 | 2712 | 15.7% | |
| 5 | 2280 | 13.2% | |
| 7 | 1458 | 8.4% | |
| 6 | 1446 | 8.4% | |
| 3 | 1338 | 7.7% | |
| 8 | 1206 | 7.0% | |
| 9 | 1008 | 5.8% | |
| 2 | 954 | 5.5% | |
| 4 | 864 | 5.0% |
Most frequent Close Punctuation characters
| Value | Count | Frequency (%) | |
| ) | 2940 | 100.0% |
Most frequent Dash Punctuation characters
| Value | Count | Frequency (%) | |
| - | 372 | 100.0% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| : | 432 | 49.7% | |
| / | 126 | 14.5% | |
| & | 120 | 13.8% | |
| . | 90 | 10.3% | |
| , | 66 | 7.6% | |
| # | 30 | 3.4% | |
| ' | 6 | 0.7% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 84126 | 69.7% | |
| Common | 36522 | 30.3% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| e | 8394 | 10.0% | |
| n | 6390 | 7.6% | |
| i | 6054 | 7.2% | |
| a | 6000 | 7.1% | |
| t | 5910 | 7.0% | |
| o | 5604 | 6.7% | |
| r | 5214 | 6.2% | |
| P | 4314 | 5.1% | |
| l | 3336 | 4.0% | |
| s | 3234 | 3.8% | |
| d | 2532 | 3.0% | |
| c | 2418 | 2.9% | |
| S | 1806 | 2.1% | |
| u | 1698 | 2.0% | |
| m | 1662 | 2.0% | |
| C | 1560 | 1.9% | |
| g | 1458 | 1.7% | |
| R | 1272 | 1.5% | |
| p | 1236 | 1.5% | |
| y | 1188 | 1.4% | |
| h | 1062 | 1.3% | |
| v | 1050 | 1.2% | |
| A | 900 | 1.1% | |
| k | 882 | 1.0% | |
| M | 846 | 1.0% | |
| Other values (26) | 8106 | 9.6% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 12108 | 33.2% | ||
| 0 | 4026 | 11.0% | |
| ( | 2940 | 8.0% | |
| ) | 2940 | 8.0% | |
| 1 | 2712 | 7.4% | |
| 5 | 2280 | 6.2% | |
| 7 | 1458 | 4.0% | |
| 6 | 1446 | 4.0% | |
| 3 | 1338 | 3.7% | |
| 8 | 1206 | 3.3% | |
| 9 | 1008 | 2.8% | |
| 2 | 954 | 2.6% | |
| 4 | 864 | 2.4% | |
| : | 432 | 1.2% | |
| - | 372 | 1.0% | |
| / | 126 | 0.3% | |
| & | 120 | 0.3% | |
| . | 90 | 0.2% | |
| , | 66 | 0.2% | |
| # | 30 | 0.1% | |
| ' | 6 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 120648 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| 12108 | 10.0% | ||
| e | 8394 | 7.0% | |
| n | 6390 | 5.3% | |
| i | 6054 | 5.0% | |
| a | 6000 | 5.0% | |
| t | 5910 | 4.9% | |
| o | 5604 | 4.6% | |
| r | 5214 | 4.3% | |
| P | 4314 | 3.6% | |
| 0 | 4026 | 3.3% | |
| l | 3336 | 2.8% | |
| s | 3234 | 2.7% | |
| ( | 2940 | 2.4% | |
| ) | 2940 | 2.4% | |
| 1 | 2712 | 2.2% | |
| d | 2532 | 2.1% | |
| c | 2418 | 2.0% | |
| 5 | 2280 | 1.9% | |
| S | 1806 | 1.5% | |
| u | 1698 | 1.4% | |
| m | 1662 | 1.4% | |
| C | 1560 | 1.3% | |
| g | 1458 | 1.2% | |
| 7 | 1458 | 1.2% | |
| 6 | 1446 | 1.2% | |
| Other values (47) | 23154 | 19.2% |
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 24 |
| Missing (%) | 0.8% |
| Memory size | 24.7 KiB |
| Other | |
|---|---|
| Planning, Design and Supervision | |
| Total Expenditures | |
| Construction | |
| Site Improvements and Utilities |
| Value | Count | Frequency (%) | |
| Other | 520 | 16.5% | |
| Planning, Design and Supervision | 520 | 16.5% | |
| Total Expenditures | 520 | 16.5% | |
| Construction | 520 | 16.5% | |
| Site Improvements and Utilities | 520 | 16.5% | |
| Land | 520 | 16.5% | |
| (Missing) | 24 | 0.8% |
Frequencies of value counts
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Histogram of lengths of the category
Length
| Max length | 32 |
|---|---|
| Median length | 12 |
| Mean length | 16.89312977 |
| Min length | 3 |
Most occurring characters
| Value | Count | Frequency (%) | |
| n | 6288 | 11.8% | |
| i | 5200 | 9.8% | |
| e | 4680 | 8.8% | |
| t | 4680 | 8.8% | |
| 3640 | 6.9% | ||
| s | 3120 | 5.9% | |
| a | 2624 | 4.9% | |
| r | 2600 | 4.9% | |
| o | 2600 | 4.9% | |
| d | 2080 | 3.9% | |
| l | 1560 | 2.9% | |
| u | 1560 | 2.9% | |
| p | 1560 | 2.9% | |
| g | 1040 | 2.0% | |
| S | 1040 | 2.0% | |
| v | 1040 | 2.0% | |
| m | 1040 | 2.0% | |
| P | 520 | 1.0% | |
| , | 520 | 1.0% | |
| D | 520 | 1.0% | |
| L | 520 | 1.0% | |
| I | 520 | 1.0% | |
| U | 520 | 1.0% | |
| C | 520 | 1.0% | |
| c | 520 | 1.0% | |
| Other values (5) | 2600 | 4.9% |
Most occurring categories
| Value | Count | Frequency (%) | |
| Lowercase Letter | 43232 | 81.4% | |
| Uppercase Letter | 5720 | 10.8% | |
| Space Separator | 3640 | 6.9% | |
| Other Punctuation | 520 | 1.0% |
Most frequent Uppercase Letter characters
| Value | Count | Frequency (%) | |
| S | 1040 | 18.2% | |
| P | 520 | 9.1% | |
| D | 520 | 9.1% | |
| L | 520 | 9.1% | |
| I | 520 | 9.1% | |
| U | 520 | 9.1% | |
| C | 520 | 9.1% | |
| O | 520 | 9.1% | |
| T | 520 | 9.1% | |
| E | 520 | 9.1% |
Most frequent Lowercase Letter characters
| Value | Count | Frequency (%) | |
| n | 6288 | 14.5% | |
| i | 5200 | 12.0% | |
| e | 4680 | 10.8% | |
| t | 4680 | 10.8% | |
| s | 3120 | 7.2% | |
| a | 2624 | 6.1% | |
| r | 2600 | 6.0% | |
| o | 2600 | 6.0% | |
| d | 2080 | 4.8% | |
| l | 1560 | 3.6% | |
| u | 1560 | 3.6% | |
| p | 1560 | 3.6% | |
| g | 1040 | 2.4% | |
| v | 1040 | 2.4% | |
| m | 1040 | 2.4% | |
| c | 520 | 1.2% | |
| h | 520 | 1.2% | |
| x | 520 | 1.2% |
Most frequent Other Punctuation characters
| Value | Count | Frequency (%) | |
| , | 520 | 100.0% |
Most frequent Space Separator characters
| Value | Count | Frequency (%) | |
| 3640 | 100.0% |
Most occurring scripts
| Value | Count | Frequency (%) | |
| Latin | 48952 | 92.2% | |
| Common | 4160 | 7.8% |
Most frequent Latin characters
| Value | Count | Frequency (%) | |
| n | 6288 | 12.8% | |
| i | 5200 | 10.6% | |
| e | 4680 | 9.6% | |
| t | 4680 | 9.6% | |
| s | 3120 | 6.4% | |
| a | 2624 | 5.4% | |
| r | 2600 | 5.3% | |
| o | 2600 | 5.3% | |
| d | 2080 | 4.2% | |
| l | 1560 | 3.2% | |
| u | 1560 | 3.2% | |
| p | 1560 | 3.2% | |
| g | 1040 | 2.1% | |
| S | 1040 | 2.1% | |
| v | 1040 | 2.1% | |
| m | 1040 | 2.1% | |
| P | 520 | 1.1% | |
| D | 520 | 1.1% | |
| L | 520 | 1.1% | |
| I | 520 | 1.1% | |
| U | 520 | 1.1% | |
| C | 520 | 1.1% | |
| c | 520 | 1.1% | |
| O | 520 | 1.1% | |
| h | 520 | 1.1% | |
| Other values (3) | 1560 | 3.2% |
Most frequent Common characters
| Value | Count | Frequency (%) | |
| 3640 | 87.5% | ||
| , | 520 | 12.5% |
Most occurring blocks
| Value | Count | Frequency (%) | |
| ASCII | 53112 | 100.0% |
Most frequent ASCII characters
| Value | Count | Frequency (%) | |
| n | 6288 | 11.8% | |
| i | 5200 | 9.8% | |
| e | 4680 | 8.8% | |
| t | 4680 | 8.8% | |
| 3640 | 6.9% | ||
| s | 3120 | 5.9% | |
| a | 2624 | 4.9% | |
| r | 2600 | 4.9% | |
| o | 2600 | 4.9% | |
| d | 2080 | 3.9% | |
| l | 1560 | 2.9% | |
| u | 1560 | 2.9% | |
| p | 1560 | 2.9% | |
| g | 1040 | 2.0% | |
| S | 1040 | 2.0% | |
| v | 1040 | 2.0% | |
| m | 1040 | 2.0% | |
| P | 520 | 1.0% | |
| , | 520 | 1.0% | |
| D | 520 | 1.0% | |
| L | 520 | 1.0% | |
| I | 520 | 1.0% | |
| U | 520 | 1.0% | |
| C | 520 | 1.0% | |
| c | 520 | 1.0% | |
| Other values (5) | 2600 | 4.9% |
| Distinct | 1670 |
|---|---|
| Distinct (%) | 53.5% |
| Missing | 24 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 16240.20192 |
|---|---|
| Minimum | -1522 |
| Maximum | 1848877 |
| Zeros | 1045 |
| Zeros (%) | 33.2% |
| Memory size | 24.7 KiB |
Quantile statistics
| Minimum | -1522 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 618 |
| Q3 | 5698.75 |
| 95-th percentile | 66548 |
| Maximum | 1848877 |
| Range | 1850399 |
| Interquartile range (IQR) | 5698.75 |
Descriptive statistics
| Standard deviation | 80384.14639 |
|---|---|
| Coefficient of variation (CV) | 4.949701165 |
| Kurtosis | 211.6527076 |
| Mean | 16240.20192 |
| Median Absolute Deviation (MAD) | 618 |
| Skewness | 12.753861 |
| Sum | 50669430 |
| Variance | 6461610990 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 1045 | 33.2% | |
| 2 | 17 | 0.5% | |
| 1 | 16 | 0.5% | |
| 4 | 10 | 0.3% | |
| 200 | 10 | 0.3% | |
| 3 | 8 | 0.3% | |
| 400 | 8 | 0.3% | |
| 20 | 7 | 0.2% | |
| 1000 | 6 | 0.2% | |
| 350 | 5 | 0.2% | |
| 10 | 5 | 0.2% | |
| 9 | 5 | 0.2% | |
| 44 | 5 | 0.2% | |
| 3000 | 4 | 0.1% | |
| 6 | 4 | 0.1% | |
| 5 | 4 | 0.1% | |
| 22 | 4 | 0.1% | |
| 500 | 4 | 0.1% | |
| 100 | 4 | 0.1% | |
| 227 | 4 | 0.1% | |
| 1900 | 4 | 0.1% | |
| 25 | 4 | 0.1% | |
| 240 | 4 | 0.1% | |
| 15 | 4 | 0.1% | |
| 7 | 4 | 0.1% | |
| Other values (1645) | 1925 | 61.2% | |
| (Missing) | 24 | 0.8% |
| Value | Count | Frequency (%) | |
| -1522 | 1 | < 0.1% | |
| 0 | 1045 | 33.2% | |
| 1 | 16 | 0.5% | |
| 2 | 17 | 0.5% | |
| 3 | 8 | 0.3% | |
| 4 | 10 | 0.3% | |
| 5 | 4 | 0.1% | |
| 6 | 4 | 0.1% | |
| 7 | 4 | 0.1% | |
| 8 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1848877 | 1 | < 0.1% | |
| 1495765 | 1 | < 0.1% | |
| 1435580 | 1 | < 0.1% | |
| 1309810 | 1 | < 0.1% | |
| 1182514 | 1 | < 0.1% | |
| 975441 | 1 | < 0.1% | |
| 870467 | 1 | < 0.1% | |
| 823420 | 1 | < 0.1% | |
| 790060 | 1 | < 0.1% | |
| 719564 | 1 | < 0.1% |
| Distinct | 949 |
|---|---|
| Distinct (%) | 30.4% |
| Missing | 24 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3889.716667 |
|---|---|
| Minimum | 0 |
| Maximum | 462612 |
| Zeros | 1831 |
| Zeros (%) | 58.2% |
| Memory size | 24.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 520 |
| 95-th percentile | 13587.85 |
| Maximum | 462612 |
| Range | 462612 |
| Interquartile range (IQR) | 520 |
Descriptive statistics
| Standard deviation | 20591.95192 |
|---|---|
| Coefficient of variation (CV) | 5.293946498 |
| Kurtosis | 178.9849607 |
| Mean | 3889.716667 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 11.51333932 |
| Sum | 12135916 |
| Variance | 424028484 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 1831 | 58.2% | |
| 1 | 26 | 0.8% | |
| 2 | 25 | 0.8% | |
| 4 | 13 | 0.4% | |
| 3 | 12 | 0.4% | |
| 8 | 10 | 0.3% | |
| 13 | 9 | 0.3% | |
| 12 | 9 | 0.3% | |
| 5 | 8 | 0.3% | |
| 23 | 6 | 0.2% | |
| 9 | 6 | 0.2% | |
| 119 | 5 | 0.2% | |
| 26 | 5 | 0.2% | |
| 34 | 5 | 0.2% | |
| 100 | 5 | 0.2% | |
| 20 | 5 | 0.2% | |
| 10 | 5 | 0.2% | |
| 44 | 5 | 0.2% | |
| 6 | 5 | 0.2% | |
| 15 | 5 | 0.2% | |
| 124 | 4 | 0.1% | |
| 165 | 4 | 0.1% | |
| 73 | 4 | 0.1% | |
| 28 | 4 | 0.1% | |
| 38 | 4 | 0.1% | |
| Other values (924) | 1100 | 35.0% | |
| (Missing) | 24 | 0.8% |
| Value | Count | Frequency (%) | |
| 0 | 1831 | 58.2% | |
| 1 | 26 | 0.8% | |
| 2 | 25 | 0.8% | |
| 3 | 12 | 0.4% | |
| 4 | 13 | 0.4% | |
| 5 | 8 | 0.3% | |
| 6 | 5 | 0.2% | |
| 7 | 3 | 0.1% | |
| 8 | 10 | 0.3% | |
| 9 | 6 | 0.2% |
| Value | Count | Frequency (%) | |
| 462612 | 1 | < 0.1% | |
| 397334 | 1 | < 0.1% | |
| 326591 | 1 | < 0.1% | |
| 263593 | 1 | < 0.1% | |
| 256979 | 1 | < 0.1% | |
| 248209 | 1 | < 0.1% | |
| 201575 | 1 | < 0.1% | |
| 192462 | 1 | < 0.1% | |
| 191111 | 2 | 0.1% | |
| 173685 | 1 | < 0.1% |
| Distinct | 948 |
|---|---|
| Distinct (%) | 30.4% |
| Missing | 24 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2692.137179 |
|---|---|
| Minimum | -18969 |
| Maximum | 336606 |
| Zeros | 1736 |
| Zeros (%) | 55.2% |
| Memory size | 24.7 KiB |
Quantile statistics
| Minimum | -18969 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 518 |
| 95-th percentile | 10782 |
| Maximum | 336606 |
| Range | 355575 |
| Interquartile range (IQR) | 518 |
Descriptive statistics
| Standard deviation | 14268.78443 |
|---|---|
| Coefficient of variation (CV) | 5.300169894 |
| Kurtosis | 220.1571038 |
| Mean | 2692.137179 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 12.7859342 |
| Sum | 8399468 |
| Variance | 203598209.1 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 1736 | 55.2% | |
| 2 | 11 | 0.3% | |
| 10 | 10 | 0.3% | |
| 100 | 10 | 0.3% | |
| 50 | 9 | 0.3% | |
| 1 | 8 | 0.3% | |
| 500 | 7 | 0.2% | |
| 25 | 7 | 0.2% | |
| 38 | 7 | 0.2% | |
| 200 | 7 | 0.2% | |
| 7 | 6 | 0.2% | |
| 4 | 6 | 0.2% | |
| 175 | 6 | 0.2% | |
| 6 | 6 | 0.2% | |
| 15 | 5 | 0.2% | |
| 53 | 5 | 0.2% | |
| 213 | 5 | 0.2% | |
| 40151 | 5 | 0.2% | |
| 300 | 5 | 0.2% | |
| 20 | 5 | 0.2% | |
| 103 | 5 | 0.2% | |
| 42 | 5 | 0.2% | |
| 514 | 5 | 0.2% | |
| 8 | 5 | 0.2% | |
| 347 | 5 | 0.2% | |
| Other values (923) | 1229 | 39.1% | |
| (Missing) | 24 | 0.8% |
| Value | Count | Frequency (%) | |
| -18969 | 1 | < 0.1% | |
| -1522 | 2 | 0.1% | |
| -174 | 1 | < 0.1% | |
| -158 | 1 | < 0.1% | |
| -120 | 1 | < 0.1% | |
| -81 | 1 | < 0.1% | |
| -37 | 1 | < 0.1% | |
| -33 | 1 | < 0.1% | |
| -25 | 1 | < 0.1% | |
| -18 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 336606 | 1 | < 0.1% | |
| 300181 | 1 | < 0.1% | |
| 225865 | 1 | < 0.1% | |
| 212960 | 1 | < 0.1% | |
| 196931 | 1 | < 0.1% | |
| 158231 | 1 | < 0.1% | |
| 154337 | 1 | < 0.1% | |
| 131456 | 1 | < 0.1% | |
| 130244 | 1 | < 0.1% | |
| 120654 | 1 | < 0.1% |
| Distinct | 1019 |
|---|---|
| Distinct (%) | 32.7% |
| Missing | 24 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9658.348077 |
|---|---|
| Minimum | 0 |
| Maximum | 1548696 |
| Zeros | 1777 |
| Zeros (%) | 56.5% |
| Memory size | 24.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1800 |
| 95-th percentile | 31884.65 |
| Maximum | 1548696 |
| Range | 1548696 |
| Interquartile range (IQR) | 1800 |
Descriptive statistics
| Standard deviation | 60022.96174 |
|---|---|
| Coefficient of variation (CV) | 6.214619857 |
| Kurtosis | 280.8441034 |
| Mean | 9658.348077 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 14.77666905 |
| Sum | 30134046 |
| Variance | 3602755936 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 1777 | 56.5% | |
| 200 | 16 | 0.5% | |
| 6000 | 12 | 0.4% | |
| 150 | 11 | 0.3% | |
| 1800 | 9 | 0.3% | |
| 300 | 9 | 0.3% | |
| 50 | 9 | 0.3% | |
| 1000 | 8 | 0.3% | |
| 3000 | 7 | 0.2% | |
| 60 | 7 | 0.2% | |
| 1500 | 6 | 0.2% | |
| 1200 | 6 | 0.2% | |
| 7500 | 6 | 0.2% | |
| 8000 | 6 | 0.2% | |
| 2000 | 6 | 0.2% | |
| 540 | 6 | 0.2% | |
| 600 | 5 | 0.2% | |
| 20 | 5 | 0.2% | |
| 33000 | 5 | 0.2% | |
| 1620 | 5 | 0.2% | |
| 240 | 5 | 0.2% | |
| 1100 | 5 | 0.2% | |
| 3300 | 5 | 0.2% | |
| 750 | 5 | 0.2% | |
| 270 | 5 | 0.2% | |
| Other values (994) | 1174 | 37.3% | |
| (Missing) | 24 | 0.8% |
| Value | Count | Frequency (%) | |
| 0 | 1777 | 56.5% | |
| 1 | 4 | 0.1% | |
| 2 | 1 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 9 | 1 | < 0.1% | |
| 10 | 1 | < 0.1% | |
| 12 | 2 | 0.1% | |
| 14 | 3 | 0.1% | |
| 15 | 1 | < 0.1% | |
| 16 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 1548696 | 1 | < 0.1% | |
| 1209715 | 1 | < 0.1% | |
| 1159159 | 1 | < 0.1% | |
| 969554 | 1 | < 0.1% | |
| 726544 | 1 | < 0.1% | |
| 712236 | 1 | < 0.1% | |
| 693176 | 1 | < 0.1% | |
| 557574 | 1 | < 0.1% | |
| 523156 | 1 | < 0.1% | |
| 522633 | 1 | < 0.1% |
| Distinct | 678 |
|---|---|
| Distinct (%) | 21.7% |
| Missing | 24 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2125.673718 |
|---|---|
| Minimum | -6000 |
| Maximum | 365379 |
| Zeros | 2014 |
| Zeros (%) | 64.1% |
| Memory size | 24.7 KiB |
Quantile statistics
| Minimum | -6000 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 270.75 |
| 95-th percentile | 7252.8 |
| Maximum | 365379 |
| Range | 371379 |
| Interquartile range (IQR) | 270.75 |
Descriptive statistics
| Standard deviation | 13485.97802 |
|---|---|
| Coefficient of variation (CV) | 6.344331168 |
| Kurtosis | 296.3952312 |
| Mean | 2125.673718 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 15.00556452 |
| Sum | 6632102 |
| Variance | 181871603.2 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 2014 | 64.1% | |
| 50 | 22 | 0.7% | |
| 1000 | 20 | 0.6% | |
| 100 | 19 | 0.6% | |
| 200 | 18 | 0.6% | |
| 300 | 16 | 0.5% | |
| 2000 | 15 | 0.5% | |
| 25 | 11 | 0.3% | |
| 350 | 11 | 0.3% | |
| 400 | 9 | 0.3% | |
| 600 | 8 | 0.3% | |
| 10 | 8 | 0.3% | |
| 250 | 8 | 0.3% | |
| 20 | 7 | 0.2% | |
| 1250 | 7 | 0.2% | |
| 60 | 6 | 0.2% | |
| 120 | 6 | 0.2% | |
| 500 | 6 | 0.2% | |
| 150 | 6 | 0.2% | |
| 3300 | 5 | 0.2% | |
| 90 | 5 | 0.2% | |
| 16000 | 5 | 0.2% | |
| 75 | 5 | 0.2% | |
| 5000 | 5 | 0.2% | |
| 450 | 5 | 0.2% | |
| Other values (653) | 873 | 27.8% | |
| (Missing) | 24 | 0.8% |
| Value | Count | Frequency (%) | |
| -6000 | 1 | < 0.1% | |
| -3000 | 1 | < 0.1% | |
| 0 | 2014 | 64.1% | |
| 1 | 4 | 0.1% | |
| 2 | 3 | 0.1% | |
| 5 | 2 | 0.1% | |
| 6 | 2 | 0.1% | |
| 8 | 2 | 0.1% | |
| 10 | 8 | 0.3% | |
| 11 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 365379 | 1 | < 0.1% | |
| 274030 | 1 | < 0.1% | |
| 238616 | 1 | < 0.1% | |
| 203751 | 1 | < 0.1% | |
| 169477 | 1 | < 0.1% | |
| 168490 | 1 | < 0.1% | |
| 145521 | 1 | < 0.1% | |
| 133804 | 1 | < 0.1% | |
| 129881 | 1 | < 0.1% | |
| 102000 | 1 | < 0.1% |
| Distinct | 665 |
|---|---|
| Distinct (%) | 21.3% |
| Missing | 24 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1952.871154 |
|---|---|
| Minimum | -6000 |
| Maximum | 347787 |
| Zeros | 2066 |
| Zeros (%) | 65.7% |
| Memory size | 24.7 KiB |
Quantile statistics
| Minimum | -6000 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 235.25 |
| 95-th percentile | 6624.95 |
| Maximum | 347787 |
| Range | 353787 |
| Interquartile range (IQR) | 235.25 |
Descriptive statistics
| Standard deviation | 12387.09123 |
|---|---|
| Coefficient of variation (CV) | 6.343015109 |
| Kurtosis | 324.4193324 |
| Mean | 1952.871154 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 15.59126993 |
| Sum | 6092958 |
| Variance | 153440029.2 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 2066 | 65.7% | |
| 100 | 19 | 0.6% | |
| 50 | 15 | 0.5% | |
| 1000 | 13 | 0.4% | |
| 500 | 13 | 0.4% | |
| 300 | 13 | 0.4% | |
| 200 | 12 | 0.4% | |
| 2000 | 11 | 0.3% | |
| 25 | 9 | 0.3% | |
| 10 | 8 | 0.3% | |
| 1250 | 7 | 0.2% | |
| 400 | 7 | 0.2% | |
| 45 | 7 | 0.2% | |
| 125 | 6 | 0.2% | |
| 700 | 6 | 0.2% | |
| 600 | 6 | 0.2% | |
| 450 | 6 | 0.2% | |
| 270 | 6 | 0.2% | |
| 550 | 6 | 0.2% | |
| 250 | 6 | 0.2% | |
| 90 | 5 | 0.2% | |
| 175 | 5 | 0.2% | |
| 150 | 5 | 0.2% | |
| 22 | 5 | 0.2% | |
| 17000 | 5 | 0.2% | |
| Other values (640) | 853 | 27.1% | |
| (Missing) | 24 | 0.8% |
| Value | Count | Frequency (%) | |
| -6000 | 1 | < 0.1% | |
| -3000 | 1 | < 0.1% | |
| 0 | 2066 | 65.7% | |
| 2 | 4 | 0.1% | |
| 4 | 1 | < 0.1% | |
| 5 | 2 | 0.1% | |
| 6 | 2 | 0.1% | |
| 7 | 3 | 0.1% | |
| 8 | 1 | < 0.1% | |
| 10 | 8 | 0.3% |
| Value | Count | Frequency (%) | |
| 347787 | 1 | < 0.1% | |
| 258988 | 1 | < 0.1% | |
| 225699 | 1 | < 0.1% | |
| 174165 | 1 | < 0.1% | |
| 157231 | 1 | < 0.1% | |
| 137269 | 1 | < 0.1% | |
| 134664 | 1 | < 0.1% | |
| 106785 | 1 | < 0.1% | |
| 102858 | 1 | < 0.1% | |
| 100420 | 1 | < 0.1% |
| Distinct | 593 |
|---|---|
| Distinct (%) | 19.0% |
| Missing | 24 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1630.662179 |
|---|---|
| Minimum | -6000 |
| Maximum | 281039 |
| Zeros | 2176 |
| Zeros (%) | 69.2% |
| Memory size | 24.7 KiB |
Quantile statistics
| Minimum | -6000 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 110.5 |
| 95-th percentile | 4804.4 |
| Maximum | 281039 |
| Range | 287039 |
| Interquartile range (IQR) | 110.5 |
Descriptive statistics
| Standard deviation | 11191.51544 |
|---|---|
| Coefficient of variation (CV) | 6.863172263 |
| Kurtosis | 279.3243029 |
| Mean | 1630.662179 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 14.99498751 |
| Sum | 5087666 |
| Variance | 125250017.9 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 2176 | 69.2% | |
| 300 | 20 | 0.6% | |
| 50 | 17 | 0.5% | |
| 100 | 13 | 0.4% | |
| 1000 | 12 | 0.4% | |
| 200 | 12 | 0.4% | |
| 10 | 10 | 0.3% | |
| 500 | 10 | 0.3% | |
| 2000 | 9 | 0.3% | |
| 150 | 8 | 0.3% | |
| 1250 | 8 | 0.3% | |
| 250 | 7 | 0.2% | |
| 600 | 7 | 0.2% | |
| 25 | 7 | 0.2% | |
| 4000 | 6 | 0.2% | |
| 160 | 6 | 0.2% | |
| 360 | 6 | 0.2% | |
| 270 | 6 | 0.2% | |
| 90 | 6 | 0.2% | |
| 45 | 6 | 0.2% | |
| 450 | 5 | 0.2% | |
| 125 | 5 | 0.2% | |
| 6 | 5 | 0.2% | |
| 1800 | 5 | 0.2% | |
| 190 | 5 | 0.2% | |
| Other values (568) | 743 | 23.6% | |
| (Missing) | 24 | 0.8% |
| Value | Count | Frequency (%) | |
| -6000 | 1 | < 0.1% | |
| -3000 | 1 | < 0.1% | |
| 0 | 2176 | 69.2% | |
| 2 | 3 | 0.1% | |
| 3 | 2 | 0.1% | |
| 5 | 2 | 0.1% | |
| 6 | 5 | 0.2% | |
| 9 | 1 | < 0.1% | |
| 10 | 10 | 0.3% | |
| 11 | 2 | 0.1% |
| Value | Count | Frequency (%) | |
| 281039 | 1 | < 0.1% | |
| 228602 | 1 | < 0.1% | |
| 212178 | 1 | < 0.1% | |
| 178297 | 1 | < 0.1% | |
| 168313 | 1 | < 0.1% | |
| 147036 | 1 | < 0.1% | |
| 129126 | 1 | < 0.1% | |
| 122640 | 1 | < 0.1% | |
| 108178 | 1 | < 0.1% | |
| 95680 | 1 | < 0.1% |
| Distinct | 533 |
|---|---|
| Distinct (%) | 17.1% |
| Missing | 24 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1535.764744 |
|---|---|
| Minimum | -1316 |
| Maximum | 259205 |
| Zeros | 2292 |
| Zeros (%) | 72.9% |
| Memory size | 24.7 KiB |
Quantile statistics
| Minimum | -1316 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 33.25 |
| 95-th percentile | 5014.5 |
| Maximum | 259205 |
| Range | 260521 |
| Interquartile range (IQR) | 33.25 |
Descriptive statistics
| Standard deviation | 10207.85879 |
|---|---|
| Coefficient of variation (CV) | 6.646759426 |
| Kurtosis | 285.8543337 |
| Mean | 1535.764744 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 14.96764931 |
| Sum | 4791586 |
| Variance | 104200381 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 2292 | 72.9% | |
| 300 | 16 | 0.5% | |
| 1000 | 14 | 0.4% | |
| 50 | 12 | 0.4% | |
| 2000 | 10 | 0.3% | |
| 100 | 10 | 0.3% | |
| 200 | 9 | 0.3% | |
| 500 | 9 | 0.3% | |
| 90 | 9 | 0.3% | |
| 1250 | 9 | 0.3% | |
| 10 | 8 | 0.3% | |
| 250 | 7 | 0.2% | |
| 700 | 7 | 0.2% | |
| 4000 | 6 | 0.2% | |
| 150 | 6 | 0.2% | |
| 45 | 6 | 0.2% | |
| 6 | 6 | 0.2% | |
| 25 | 6 | 0.2% | |
| 1500 | 6 | 0.2% | |
| 270 | 5 | 0.2% | |
| 160 | 4 | 0.1% | |
| 30 | 4 | 0.1% | |
| 600 | 4 | 0.1% | |
| 418 | 4 | 0.1% | |
| 350 | 4 | 0.1% | |
| Other values (508) | 647 | 20.6% | |
| (Missing) | 24 | 0.8% |
| Value | Count | Frequency (%) | |
| -1316 | 2 | 0.1% | |
| 0 | 2292 | 72.9% | |
| 2 | 3 | 0.1% | |
| 3 | 1 | < 0.1% | |
| 5 | 2 | 0.1% | |
| 6 | 6 | 0.2% | |
| 9 | 1 | < 0.1% | |
| 10 | 8 | 0.3% | |
| 12 | 2 | 0.1% | |
| 14 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 259205 | 1 | < 0.1% | |
| 209647 | 1 | < 0.1% | |
| 205236 | 1 | < 0.1% | |
| 169368 | 1 | < 0.1% | |
| 130060 | 1 | < 0.1% | |
| 120483 | 1 | < 0.1% | |
| 111821 | 1 | < 0.1% | |
| 97069 | 1 | < 0.1% | |
| 89791 | 1 | < 0.1% | |
| 79553 | 1 | < 0.1% |
| Distinct | 490 |
|---|---|
| Distinct (%) | 15.7% |
| Missing | 24 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1285.091026 |
|---|---|
| Minimum | 0 |
| Maximum | 177744 |
| Zeros | 2384 |
| Zeros (%) | 75.8% |
| Memory size | 24.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 4390.6 |
| Maximum | 177744 |
| Range | 177744 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 7907.592086 |
|---|---|
| Coefficient of variation (CV) | 6.153332276 |
| Kurtosis | 229.5568907 |
| Mean | 1285.091026 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 13.2775633 |
| Sum | 4009484 |
| Variance | 62530012.6 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 2384 | 75.8% | |
| 50 | 15 | 0.5% | |
| 100 | 15 | 0.5% | |
| 300 | 12 | 0.4% | |
| 10 | 11 | 0.3% | |
| 200 | 10 | 0.3% | |
| 1000 | 10 | 0.3% | |
| 1250 | 9 | 0.3% | |
| 125 | 7 | 0.2% | |
| 250 | 7 | 0.2% | |
| 150 | 6 | 0.2% | |
| 90 | 6 | 0.2% | |
| 45 | 6 | 0.2% | |
| 25 | 6 | 0.2% | |
| 4000 | 6 | 0.2% | |
| 270 | 5 | 0.2% | |
| 6000 | 5 | 0.2% | |
| 500 | 5 | 0.2% | |
| 460 | 4 | 0.1% | |
| 8500 | 4 | 0.1% | |
| 700 | 4 | 0.1% | |
| 600 | 4 | 0.1% | |
| 2000 | 4 | 0.1% | |
| 140 | 3 | 0.1% | |
| 8600 | 3 | 0.1% | |
| Other values (465) | 569 | 18.1% | |
| (Missing) | 24 | 0.8% |
| Value | Count | Frequency (%) | |
| 0 | 2384 | 75.8% | |
| 2 | 3 | 0.1% | |
| 5 | 1 | < 0.1% | |
| 6 | 2 | 0.1% | |
| 8 | 1 | < 0.1% | |
| 10 | 11 | 0.3% | |
| 12 | 1 | < 0.1% | |
| 14 | 1 | < 0.1% | |
| 15 | 1 | < 0.1% | |
| 18 | 2 | 0.1% |
| Value | Count | Frequency (%) | |
| 177744 | 1 | < 0.1% | |
| 173199 | 1 | < 0.1% | |
| 144716 | 1 | < 0.1% | |
| 114618 | 1 | < 0.1% | |
| 105814 | 1 | < 0.1% | |
| 98866 | 1 | < 0.1% | |
| 81163 | 1 | < 0.1% | |
| 79792 | 1 | < 0.1% | |
| 71930 | 1 | < 0.1% | |
| 63553 | 1 | < 0.1% |
| Distinct | 431 |
|---|---|
| Distinct (%) | 13.8% |
| Missing | 24 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1128.284615 |
|---|---|
| Minimum | 0 |
| Maximum | 190630 |
| Zeros | 2454 |
| Zeros (%) | 78.1% |
| Memory size | 24.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 3281 |
| Maximum | 190630 |
| Range | 190630 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 7379.075902 |
|---|---|
| Coefficient of variation (CV) | 6.540083771 |
| Kurtosis | 240.5057784 |
| Mean | 1128.284615 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 13.46482281 |
| Sum | 3520248 |
| Variance | 54450761.17 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 2454 | 78.1% | |
| 300 | 14 | 0.4% | |
| 50 | 13 | 0.4% | |
| 100 | 11 | 0.3% | |
| 200 | 11 | 0.3% | |
| 1000 | 10 | 0.3% | |
| 150 | 9 | 0.3% | |
| 10 | 9 | 0.3% | |
| 1250 | 9 | 0.3% | |
| 250 | 8 | 0.3% | |
| 125 | 7 | 0.2% | |
| 25 | 6 | 0.2% | |
| 45 | 6 | 0.2% | |
| 90 | 6 | 0.2% | |
| 270 | 5 | 0.2% | |
| 500 | 5 | 0.2% | |
| 80 | 5 | 0.2% | |
| 460 | 4 | 0.1% | |
| 1500 | 4 | 0.1% | |
| 4000 | 4 | 0.1% | |
| 3000 | 4 | 0.1% | |
| 1800 | 4 | 0.1% | |
| 700 | 4 | 0.1% | |
| 20000 | 3 | 0.1% | |
| 335 | 3 | 0.1% | |
| Other values (406) | 502 | 16.0% | |
| (Missing) | 24 | 0.8% |
| Value | Count | Frequency (%) | |
| 0 | 2454 | 78.1% | |
| 2 | 3 | 0.1% | |
| 3 | 1 | < 0.1% | |
| 5 | 1 | < 0.1% | |
| 6 | 3 | 0.1% | |
| 10 | 9 | 0.3% | |
| 12 | 1 | < 0.1% | |
| 14 | 2 | 0.1% | |
| 15 | 1 | < 0.1% | |
| 18 | 2 | 0.1% |
| Value | Count | Frequency (%) | |
| 190630 | 1 | < 0.1% | |
| 125625 | 1 | < 0.1% | |
| 118994 | 1 | < 0.1% | |
| 117542 | 1 | < 0.1% | |
| 97294 | 1 | < 0.1% | |
| 93732 | 1 | < 0.1% | |
| 85820 | 1 | < 0.1% | |
| 67531 | 2 | 0.1% | |
| 65282 | 1 | < 0.1% | |
| 61744 | 1 | < 0.1% |
| Distinct | 154 |
|---|---|
| Distinct (%) | 4.9% |
| Missing | 24 |
| Missing (%) | 0.8% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1194.888462 |
|---|---|
| Minimum | 0 |
| Maximum | 246835 |
| Zeros | 2929 |
| Zeros (%) | 93.2% |
| Memory size | 24.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 502 |
| Maximum | 246835 |
| Range | 246835 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 10647.41339 |
|---|---|
| Coefficient of variation (CV) | 8.91080108 |
| Kurtosis | 225.4045121 |
| Mean | 1194.888462 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 13.57698914 |
| Sum | 3728052 |
| Variance | 113367412 |
| Monotocity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) | |
| 0 | 2929 | 93.2% | |
| 1586 | 4 | 0.1% | |
| 125 | 4 | 0.1% | |
| 109366 | 4 | 0.1% | |
| 50 | 3 | 0.1% | |
| 400 | 3 | 0.1% | |
| 7458 | 3 | 0.1% | |
| 6530 | 3 | 0.1% | |
| 501 | 3 | 0.1% | |
| 11684 | 2 | 0.1% | |
| 600 | 2 | 0.1% | |
| 780 | 2 | 0.1% | |
| 7031 | 2 | 0.1% | |
| 1199 | 2 | 0.1% | |
| 44123 | 2 | 0.1% | |
| 778 | 2 | 0.1% | |
| 52594 | 2 | 0.1% | |
| 9690 | 2 | 0.1% | |
| 232 | 2 | 0.1% | |
| 1536 | 2 | 0.1% | |
| 1216 | 2 | 0.1% | |
| 240 | 2 | 0.1% | |
| 17058 | 2 | 0.1% | |
| 7950 | 2 | 0.1% | |
| 521 | 2 | 0.1% | |
| Other values (129) | 132 | 4.2% | |
| (Missing) | 24 | 0.8% |
| Value | Count | Frequency (%) | |
| 0 | 2929 | 93.2% | |
| 11 | 1 | < 0.1% | |
| 21 | 1 | < 0.1% | |
| 40 | 1 | < 0.1% | |
| 50 | 3 | 0.1% | |
| 52 | 1 | < 0.1% | |
| 59 | 1 | < 0.1% | |
| 80 | 1 | < 0.1% | |
| 85 | 1 | < 0.1% | |
| 91 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 246835 | 1 | < 0.1% | |
| 224573 | 1 | < 0.1% | |
| 167072 | 1 | < 0.1% | |
| 147635 | 1 | < 0.1% | |
| 134610 | 1 | < 0.1% | |
| 131668 | 1 | < 0.1% | |
| 121990 | 1 | < 0.1% | |
| 109366 | 4 | 0.1% | |
| 97030 | 1 | < 0.1% | |
| 87806 | 1 | < 0.1% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.First rows
| Project | Cost Element | Total | Thru FY15 | Est FY16 | 6 Year Total | FY 17 | FY 18 | FY 19 | FY 20 | FY 21 | FY 22 | Beyond 6 Yrs | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Council Office Building Renovations (P010100) | Planning, Design and Supervision | 2553.0 | 669.0 | 334.0 | 1550.0 | 1000.0 | 550.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 1 | Council Office Building Renovations (P010100) | Land | 4.0 | 4.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 2 | Council Office Building Renovations (P010100) | Site Improvements and Utilities | 2.0 | 2.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 3 | Council Office Building Renovations (P010100) | Construction | 36414.0 | 3272.0 | 293.0 | 32849.0 | 19785.0 | 13064.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 4 | Council Office Building Renovations (P010100) | Other | 1218.0 | 8.0 | 0.0 | 1210.0 | 610.0 | 600.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 5 | Council Office Building Renovations (P010100) | Total Expenditures | 40191.0 | 3955.0 | 627.0 | 35609.0 | 21395.0 | 14214.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 6 | Council Office Building Garage (P011601) | Planning, Design and Supervision | 875.0 | 0.0 | 159.0 | 716.0 | 395.0 | 263.0 | 58.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 7 | Council Office Building Garage (P011601) | Land | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 8 | Council Office Building Garage (P011601) | Site Improvements and Utilities | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 9 | Council Office Building Garage (P011601) | Construction | 3884.0 | 0.0 | 0.0 | 3884.0 | 1748.0 | 2136.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
Last rows
| Project | Cost Element | Total | Thru FY15 | Est FY16 | 6 Year Total | FY 17 | FY 18 | FY 19 | FY 20 | FY 21 | FY 22 | Beyond 6 Yrs | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3134 | Mass Transit (SC96) | Site Improvements and Utilities | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 3135 | Mass Transit (SC96) | Construction | 5294.0 | 0.0 | 5294.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 3136 | Mass Transit (SC96) | Other | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 3137 | Mass Transit (SC96) | Total Expenditures | 5317.0 | 0.0 | 5317.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 3138 | WMATA | Planning, Design and Supervision | 23.0 | 0.0 | 23.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 3139 | WMATA | Land | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 3140 | WMATA | Site Improvements and Utilities | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 3141 | WMATA | Construction | 5294.0 | 0.0 | 5294.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 3142 | WMATA | Other | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
| 3143 | WMATA | Total Expenditures | 5317.0 | 0.0 | 5317.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |